package com.cms.biz.category;

public class SQLString {
   public static String ADD_CATEGORY = "insert into cms_category(category_name,type_id,folder_id,parent_id,create_user)values(?,?,0,?,?)";
   public static String GET_CATEGORY_BY_TYPE_ID = "select * from cms_category where folder_id = 0 and type_id = ? and parent_id = 0 order by id asc";
   public static String GET_CATEGORY_BY_PARENT_ID = "select * from cms_category where folder_id = 0 and parent_id = ? order by id asc";
   public static String UPDATE_CATEGORY_BY_ID = "update cms_category set category_name=?,parent_id=? where id = ?";
   public static String DELETE_CATEGORY_BY_ID = "update cms_category set folder_id = 1 where id = ?";
}
